package tt.dz.dao.ext.system;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
import tt.dz.entity.base.OmsServiceSplitRatioEntity;
import tt.dz.entity.system.OmsUrlListEntity;

@Repository
public interface OmsUrlListRepo extends JpaRepository<OmsUrlListEntity, String>
{
	//	@Query(" SELECT max(cast(url_id AS SIGNED INTEGER)) AS maxId FROM OmsUrlList ")
	//	@Query(" SELECT max(convert(urlId, SIGNED)) AS maxId FROM OmsUrlListEntity ")
	@Query(value = " SELECT max(convert(url_id, SIGNED)) FROM oms_url_list ", nativeQuery = true)
	String findMaxId();
}
